(*
	Purpose: Demo to create a Sqlite3 database, create a simple table and insert data into it
	Author: Michael 
	Date: 15-Feb-2007
*)

set head to "sqlite3 ~/desktop/TestDB.db" & space & quote
set tail to quote

set sql to "create table Demo(firstname, lastname, country);"
set sql to sql & "insert into Demo values('Michael', 'Liu', 'Canada');"
set sql to sql & "insert into Demo values('Bill', 'Gates', 'USA');"
set sql to sql & "insert into Demo values('George', 'Bush', 'Mars');"

do shell script head & sql & tail




